Lamar State College - Port Arthur

House Bill 2504

Spring 2018 Course Syllabus

POFI-2350-01 - Databases

 
Printer Friendly Syllabus
 
Faculty Information
SemesterSpring 2018
InstructorMedhekar, Sarita V
Phone(409) 984-6390
E-mailmedhekarsv@lamarpa.edu
Department
Business and Technology
Chair:Sheila Guillot
Phone:(409) 984-6381
E-mail:guillsr@lamarpa.edu
Office
Hours:M 1- 2; W- F 12 - 2.30; TU-TR 9 - 11;
Building:Madison Monroe Education (MMED)
Room:144
MyLamarPA Be sure to check your campus E-mail and Course Homepage using MyLamarPA campus web portal (My.LamarPA.edu). When you’ve logged in, click the email icon in the upper right-hand corner to check email, or click on the “My Courses” tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLamarPA.
Course Information
Course Number11405
Course Description In-depth instruction of database theory and the practical applications of a database. This course is designed to be repeated multiple times to improve student proficiency.
Course Prerequisites None.
Required Textbooks Benchmark Series: Microsoft Access 2016 Level 1 by Rutkosky, Roggenkamp, Rutkosky. (Combination of book with workbook and access code) ISBN 978-0763869557

You will also need a flash drive or a cloud account to save work onto.
Attendance Policy Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. A tardy is an absence for attendance purposes.

4 absences = one letter grade drop
6 absences = two letter grade drop
8 absences = automatic failure of class

Quizzes may be given at the beginning of the class period. Students coming in to class late will not be allowed to take quizzes already turned in. A grade of zero will be recorded for the quiz.

Assignments are due at the beginning of each class; student assignments coming in late will be assessed a penalty, even if the student arrives to class late and turns in work.

Students are responsible for completing all assigned homework, including reading assignments, by the required due dates and for being prepared for each class meeting. This applies even if you were absent from the previous class meeting.
Course Grading Scale  90 - 100=A    80 - 89=B    70 - 79=C     60 - 69=D    Below 59 = F
Determination of Final Grade Assignments and Quizzes - 10%, Exams - 30%, Projects - 60%
Final Exam Date May 4, 2018 - 8:00 AM   Through  May 4, 2018 - 10:30 AM
Major Assignments Course Schedule:
Week 1: Syllabus review, pre-test, Blackboard and Self Service Banner
Microsoft-Office download information. (https://www.lamarpa.edu/Lamar/media/Lamar/Files/Microsoft-Office-Pro-Plus-Installation-Video.mp4)
For each week there will be assignments and lab-work.
Week 2: Managing and Creating Access Tables; Chapter 1 of Access 2016 Level 1
Week 3: Creating Relationship between Tables; Chapter 2 of Access 2016 Level 1
Week 4: Performing Queries; Chapter 3 of Access 2016 Level 1
Week 5: Performing Queries; Chapter 3 of Access 2016 Level 1
Week 6: Creating and Modifying Tables in Design View; Chapter 4 of Access 2016 Level 1
Week 7: Creating and Modifying Tables in Design View; Chapter 4 of Access 2016 Level 1
Week 8: Mid-term Exam and Project 1
Week 9: March 12 - 16 Spring Break
Week 10: Creating Forms; Chapter 5 of Access 2016 Level 1
Week 11: Creating Reports and Mailing Labels; Chapter 6 of Access 2016 Level 1
Week 12: Modifying, Filtering, and Viewing Data; Chapter 7 of Access 2016 Level 1
Week 13: Modifying, Filtering, and Viewing Data; Chapter 7 of Access 2016 Level 1
Week 14: Exporting and importing Data; Chapter 8 of Access 2016 Level 1
Week 15: Course Review and Project II
Week 16: Final Exam
Schedule is subject to change
Calendar of Lecture Topics and Major Assignment Due Dates Course Schedule:
Week 1: January 15 Syllabus review, pre-test, Blackboard and Self Service Banner

Microsoft-Office download information. (https://www.lamarpa.edu/Lamar/media/Lamar/Files/Microsoft-Office-Pro-Plus-Installation-Video.mp4)

For each week there will be assignments and lab-work.
Week 2: January 22 Managing and Creating Access Tables
Week 3: January 29 Creating Relationship between Tables
Week 4: February 5 Performing Queries
Week 5: February 12 Performing Queries
Week 6: February 19 Creating and Modifying Tables in Design View
Week 7: February 26 Creating and Modifying Tables in Design View
Week 8: March 5 Mid-term Exam and Project 1
Week 9: March 12 - 16 Spring Break
Week 10: March 19 Creating Forms
Week 11: March 26 Creating Reports and Mailing Labels
Week 12: April 2 Modifying, Filtering, and Viewing Data
Week 13: April 9 Modifying, Filtering, and Viewing Data
Week 14: April 16 Exporting and importing Data
Week 15: April 23 Course Review and Project II
Week 16: April 30 Final Exam
Schedule is subject to change
General Education/Core Curriculum Student Learning Outcomes
Communication skills:Students will demonstrate effective written, oral and visual communication.
Critical Thinking Skills:Students will engage in creative and/or innovative thinking, and/or inquiry, analysis, evaluation, synthesis of information, organizing concepts and constructing solutions.
Empirical and Quantitative Skills:Students will demonstrate applications of scientific and mathematical concepts.
Teamwork:Students will demonstrate the ability to work effectively with others to support a shared purpose or goal and consider different points of view.
Social Responsibility:Students will demonstrate intercultural competency and civic knowledge by engaging effectively in local, regional, national and/or global communities.
Personal Responsibility:Students will demonstrate the ability to connect choices, actions and consequences to ethical decision-making.
Program Student Learning Outcomes PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material.
PSLO 1. Demonstrates appropriate professionalism in the administrative workplace.
PSLO 2. Uses current business administration skills.
PSLO 3. Uses current business office software applications.
PSLO 4. Proofreads and edits business documents.
Course Student Learning Outcomes Alpha. Demonstrates comprehension of content-area reading material (PSLO Alpha) measured by pre-test/post-test.
1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading. (PSLO ALPHA); measured by pre- and post-tests.
2. Develop an understanding of database theory and the practical applications of a database. (PSLO 3); measured by quiz.
3. Structure a database. (PSLO 3); measured by end of chapter Assessment assignment.
4. Create and format tables, forms, and reports.(PSLO 3); measured by end of chapter Assessment assignment.
5. Create and modify queries. (PSLO 3); measured by end of chapter Assessment assignment.
6. Manipulate data. (PSLO 3); measured by end of chapter Assessment assignment.
7. Proofread and edit database. (PSLO 4); measured by end of chapter Assessment assignment.
Academic Honesty Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.
Facility Policies
  • No food or tobacco products are allowed in the classroom.

  • Only students enrolled in the course are allowed in the classroom, except by special instructor permission.

  • Electronic devices (including but not restricted to cell phones, MP3 players, and laptop computers) shall not be used during examinations unless specifically allowed by the instructor.

  • Use of electronic devices during normal class hours distracts other students, disrupts the class, and wastes valuable time. Instructors have an obligation to reduce such disruptions.

  • Turn your cellphones to vibrate when you enter the classroom.
Additional Information I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must come to my office in person.

Homework assignments will be given each week.

LATE WORK is highly discouraged and will incur a 10 point penalty for every day it is late. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS.

If you miss an exam, your lowest test grade will count twice. If you miss more than one exam, those exams will be given a grade of zero. Students must leave the classroom after exam is finished.

There will be a final exam. All students must take the exam on the scheduled date and time, and failure to do so will result in a 0 on the final exam.

Every student MUST have a copy of the required textbooks by the SECOND week of class. The student will still be responsible for any assignments given. Failure to have a text may result in being dropped from the class.

No emailed work is accepted.

Students are responsible for completing all assigned reading and video viewings.

A failure to follow oral and/or written instructions will result in penalties.
Academic dishonesty will result in a zero on any assignment; a second incidence of academic dishonesty will be handled based on campus policies and procedures with the department chair.

Student IDs are required for the first exam. IDs must be visible on your desk before the exam is administered. No ID, No exam.

Software Requirements:
If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library.

Reliable Internet access is required for all online courses and many traditional courses.

Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. DO NOT wait until the last minute to complete class work or exams.

Classroom Etiquette:
The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; leaving class early without informing the instructor in advance; surfing the Internet during lecture; and displaying a rude or negative behavior toward the instructor or other students.

No cell phones should be visible or heard during class. Again, you will be asked to leave the room for the remainder of the class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones in the classroom.

E-Mail/Voice Mail Etiquette:
Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number.
Important Information
ADA Considerations The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
Copyright Violations Some material in this course may be copyrighted. They may be used only for instructional purposes this semester, by students enrolled in this course. These materials are being used fairly and legally. No one may distribute or share these copyrighted materials in any medium or format with anyone outside this class, including publishing essays with copyrighted material, uploading copyrighted material to Facebook or YouTube, or painting or performing copyrighted material for public display.

Copyright violation is not the same thing as plagiarism. Plagiarism is intellectual dishonesty. Offenses of plagiarism result in lower grades or failing scores, and professors and the college strictly enforce plagiarism rules. There is never any acceptable use of plagiarism. Copyright violation is a legal offense, punishable by large fines and penalties.

Copyrighted material can be used if permission from the material’s creator is obtained, or if its use meets the standards of fair use in an educational setting. For example, a student can quote a line from Shakespeare’s Hamlet in a report without violating copyright but still be guilty of plagiarism if the quotation is not properly documented.

If you are in doubt about what material can be freely used, ask your professor or contact the Dean of Library Services, at (409) 984-6216.
Assessment Statement Assessment is a process by which LSCPA can help you learn better and gauge the level of progress you have made to attain knowledge, skills, beliefs, and values. It also helps your professors understand how to improve teaching and testing methods in your classes, and it helps each department understand and improve degree and certificate programs.

Periodically LSC-PA will collect assessment data for research and reporting purposes, including statistical data and sometimes copies of your work. Be assured that all material the college uses for assessment purposes will be kept confidential. To ensure anonymity, your name will be removed from any material we use for assessment purposes, including video-recorded performances, speeches, and projects.

If you object to allowing LSC-PA to use your material for assessment purposes, submit a letter stating so to your professor by the 12th class day. You will still be required to participate in whatever assessments are being done; we just won’t use your data.

What’s the difference between assessment and grades? The grades you get on papers, projects, speeches, and assignments are specific types of focused assessment. LSC-PA’s assessment efforts include class grades, surveys, standardized tests, and other tools.
Privacy Notice Federal privacy laws apply to college students. This means that college employees, including instructors, cannot divulge information to third parties, including parents and legal guardians of students. Even if the students are minors, information about their college work cannot be shared with anyone except in very limited circumstances.

Anyone requesting information about a student should be referred to the Registrar. Instructors will be notified in writing by that Office about what information may be released and to whom.

Please remember that releasing private information about a student, however innocuous it may seem, can be a violation of federal law, with very serious consequences.

Circumstances under which information may be released:

An adult student may submit, to the Registrar, a handwritten, signed note granting permission for release of information. The note must specify what information may be divulged, and it must specify the name of the person to whom the information may be given.

A parent or guardian may be given access to information about a student by providing a copy of a filed tax return that shows that the student was listed as a dependent of that parent or guardian. The tax return must be for last complete tax year. Again, this documentation must be submitted to the Registrar’s Office.

A parent or guardian may be given access to information about a student if the student logs on to My.LamarPA.edu and sends an email to the Registrar granting permission. The email must specify what information may be given and the name of the person to whom it may be given.

Co-enrollment students are protected by the same privacy laws as adult students.

The Registrar’s office is located in the Student Center room 303B, and can be reached at (409) 984-6165.

College-Level Perspectives This course helps add to the students’ overall collegiate experience in the following ways:

  • Establishing broad and multiple perspectives on the individual in relationship to the larger society and world in which s/he lives, and to understand the responsibilities of living in a culturally and ethnically diversified world.

  • Stimulating a capacity to discuss and reflect upon individual, political, economic, and social aspects of life in order to understand ways in which to be a responsible member of society.

  • Developing a capacity to use knowledge of how technology and science affect their lives.

  • Developing personal values for ethical behavior.

  • Developing the ability to make aesthetic judgments.

  • Using logical reasoning in problem solving.

  • Integrating knowledge and understand the interrelationships of the scholarly disciplines.

Degree Plan Evaluation A Degree Plan Evaluation will help you determine which classes you need to complete your program.

  1. Sign in to your my.lamarpa.edu account.

  2. Click on the “My Services” tab.

  3. Click on the “Student” tab.

  4. Click on Student Records.

  5. Click on Degree Evaluation.

  6. Select the term you are planning on registering for (i.e. Summer I, Summer II, Fall, or Spring)

  7. Verify that the Curriculum Information (your MAJOR) is correct

  8. Click on “Generate New Evaluation” at the bottom of the screen.

  9. Click the radio button next to Program

  10. Click on the Generate Request button.

All of the classes that you have taken that apply to your declared major will be listed on the right. If you have a class that still needs to be completed, a “NO” will be listed on the right next to the required class.

HB 2504 This syllabus is part of LSC-PA’s efforts to comply with Texas House Bill 2504.

Lamar State College - Port Arthur

Mission
Lamar State College - Port Arthur, a member of The Texas State University System, is an open-access, comprehensive public two-year college offering quality and affordable instruction leading to associate degrees and a variety of certificates. The College embraces the premise that education is an ongoing process that enhances career potential, broadens intellectual horizons, and enriches life.

Core Values
  • Shared commitment by faculty, staff and administration to a mission characterized by student learning, diversity, and community involvement

  • General education/core curriculum that develops the values and concepts that allow the student to make a meaningful contribution in the workplace or community

  • Academic and technical programs designed to fulfill our commitment to accommodate students with diverse goals and backgrounds, using a variety of delivery methods, on and off campus

  • Technical education programs that provide for the acquisition of the knowledge, skills and behavior necessary for initial and continued employment

  • Student achievement characterized by attainment of individual goals and measured by successful accomplishments and completion of curriculum

  • Co-curricular opportunities that develop social, financial and civic acuity

Principles
Lamar State College - Port Arthur operates in the belief that all individuals should be:

  • treated with dignity and respect;

  • afforded equal opportunity to acquire a complete educational experience;

  • given an opportunity to discover and develop their special aptitudes and insights; and,

  • provided an opportunity to equip themselves for a fulfilling life and responsible citizenship in a world characterized by change.

 
Printer Friendly Syllabus